﻿<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default.aspx.vb" Inherits="_Default" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title>Gestion des logs de votre noyaux Res@mu.</title>
</head>
<body>
    <form id="form1" runat="server">
    <div align="center">
        <table id="TABLEMEP" align="center" border="0" cellspacing="0" width="800">
            <tr>
                <td bgcolor="#ff9900" colspan="3">
                    <strong><span style="color: #ffffff; font-family: Arial">Gestion des connexions aux
                        Web Services de votre noyaux Res@mu</span></strong></td>
            </tr>
            <tr>
                <td colspan="3" style="font-size: x-small; font-family: Arial">
                    <asp:GridView ID="GridView1" runat="server" AllowPaging="True" AllowSorting="True"
                        AutoGenerateColumns="False" CellPadding="4"
                        EmptyDataText="Il n'y a aucun enregistrement de données à afficher." ForeColor="#333333"
                        GridLines="None" Width="100%" DataKeyNames="logid" DataSourceID="SqlDataSource1">
                        <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
                        <RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
                        <EditRowStyle BackColor="#999999" />
                        <SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
                        <PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
                        <HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
                        <AlternatingRowStyle BackColor="White" ForeColor="#284775" />
                        <Columns>
                            <asp:BoundField DataField="logid" HeaderText="logid" ReadOnly="True" SortExpression="logid" />
                            <asp:BoundField DataField="logdate" HeaderText="logdate" SortExpression="logdate" />
                            <asp:BoundField DataField="idresamu" HeaderText="idresamu" SortExpression="idresamu" />
                            <asp:BoundField DataField="operation" HeaderText="operation" SortExpression="operation" />
                            <asp:BoundField DataField="resultat" HeaderText="resultat" SortExpression="resultat" />
                        </Columns>
                    </asp:GridView>
                    <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConflictDetection="CompareAllValues"
                        ConnectionString="<%$ ConnectionStrings:ConnectionString %>" DeleteCommand="DELETE FROM [log_info] WHERE [logid] = @original_logid AND [logdate] = @original_logdate AND [idresamu] = @original_idresamu AND [operation] = @original_operation AND [resultat] = @original_resultat"
                        InsertCommand="INSERT INTO [log_info] ([logid], [logdate], [idresamu], [operation], [resultat]) VALUES (@logid, @logdate, @idresamu, @operation, @resultat)"
                        OldValuesParameterFormatString="original_{0}" SelectCommand="SELECT [logid], [logdate], [idresamu], [operation], [resultat] FROM [log_info]"
                        UpdateCommand="UPDATE [log_info] SET [logdate] = @logdate, [idresamu] = @idresamu, [operation] = @operation, [resultat] = @resultat WHERE [logid] = @original_logid AND [logdate] = @original_logdate AND [idresamu] = @original_idresamu AND [operation] = @original_operation AND [resultat] = @original_resultat">
                        <DeleteParameters>
                            <asp:Parameter Name="original_logid" Type="String" />
                            <asp:Parameter Name="original_logdate" Type="DateTime" />
                            <asp:Parameter Name="original_idresamu" Type="String" />
                            <asp:Parameter Name="original_operation" Type="String" />
                            <asp:Parameter Name="original_resultat" Type="String" />
                        </DeleteParameters>
                        <UpdateParameters>
                            <asp:Parameter Name="logdate" Type="DateTime" />
                            <asp:Parameter Name="idresamu" Type="String" />
                            <asp:Parameter Name="operation" Type="String" />
                            <asp:Parameter Name="resultat" Type="String" />
                            <asp:Parameter Name="original_logid" Type="String" />
                            <asp:Parameter Name="original_logdate" Type="DateTime" />
                            <asp:Parameter Name="original_idresamu" Type="String" />
                            <asp:Parameter Name="original_operation" Type="String" />
                            <asp:Parameter Name="original_resultat" Type="String" />
                        </UpdateParameters>
                        <InsertParameters>
                            <asp:Parameter Name="logid" Type="String" />
                            <asp:Parameter Name="logdate" Type="DateTime" />
                            <asp:Parameter Name="idresamu" Type="String" />
                            <asp:Parameter Name="operation" Type="String" />
                            <asp:Parameter Name="resultat" Type="String" />
                        </InsertParameters>
                    </asp:SqlDataSource>
                    &nbsp; &nbsp;&nbsp;
                </td>
            </tr>
            <tr>
                <td align="right" bgcolor="lightslategray" colspan="3">
                    <asp:LinkButton ID="LBtn" runat="server" Font-Names="Arial" Font-Size="X-Small" ForeColor="White"
                        ToolTip="Supprimer tous les logs">Logs Reset</asp:LinkButton></td>
            </tr>
        </table>
    
    </div>
    </form>
</body>
</html>
